namespace ASPMVC_first_app.Migrations
{
    using System;
    using System.Data.Entity.Migrations;
    
    public partial class FillMemmbershipTable : DbMigration
    {
        public override void Up()
        {
            Sql("INSERT INTO dbo.MembershipTypes(Name, DiscountRate, DurationInMonth, Price) VALUES ('Free', 0, 0, 0)");

            Sql("INSERT INTO dbo.MembershipTypes(Name, DiscountRate, DurationInMonth, Price) VALUES ('Bronze', 5, 1, 100)");

            Sql("INSERT INTO dbo.MembershipTypes(Name, DiscountRate, DurationInMonth, Price) VALUES ('Silver', 10, 3, 250)");

            Sql("INSERT INTO dbo.MembershipTypes(Name, DiscountRate, DurationInMonth, Price) VALUES ('Gold', 15, 6, 500)");
        }
        
        public override void Down()
        {
        }
    }
}
